Class TXLSWorksheet

DescriptionHierarchyFieldsMethodsProperties

Unit

Declaration

type TXLSWorksheet = class(TIndexObject)

Description

no description available, TIndexObject description follows

Hierarchy

Overview

Methods

Public constructor Create(AClassFactory: TXLSClassFactory; AOwner: TXLSWorkbook; AManager: TXc12Manager; AXc12Sheet: TXc12DataWorksheet);
Public destructor Destroy; override;
Public function RequestObject(AClass: TClass): TObject; override;
Public function MakeFormattedText(const ACell: TXLSCellItem): TXLSFormattedText; overload;
Public function MakeFormattedText(const ACol,ARow: integer; var AFormattedText: TXLSFormattedText): boolean; overload;
Public procedure Assign(Source: TXLSWorksheet);
Public function MMUCells: TXLSCellMMU;
Public procedure Clear;
Public procedure ClearData;
Public procedure ClearWorksheet;
Public procedure FillRandom(const AArea: AxUCString;const AValue: integer);
Public function AutoWidthCol(const ACol: integer): integer;
Public procedure AutoWidthCols(const Col1,Col2: integer);
Public function AutoHeightRow(const ARow: integer): boolean;
Public function AutoHeightRows(const Row1,Row2: integer): boolean;
Public procedure AutoSizeCell(const ACol,ARow: integer; const ASizeCol,ASizeRow: boolean);
Public procedure UnfreezePanes;
Public procedure FreezePanes(const AColumns,ARows: integer);
Public procedure UnsplitPanes;
Public procedure SplitPanes(const APointsWidth,APointsHeight: integer);
Public procedure CalcDimensions;
Public procedure CalcDimensionsEx;
Public function Calculate(const ACol, ARow: integer): Variant;
Public function CalculateEx(Col, Row: integer; CalculateOptions: boolean): Variant;
Public function CalculateAsString(const ACol, ARow: integer): AxUCString;
Public procedure CalculateSheet;
Public procedure Calculated(const IsCalculated: boolean);
Public procedure CopyCell(const ACol, ARow, ADestCol, ADestRow: integer);
Public procedure CopyCells(const ACol1, ARow1, ACol2, ARow2, ADestCol, ADestRow: integer; const ACopyOptions: TCopyCellsOptions = CopyAllCells);
Public procedure DeleteCell(const ACol, ARow: integer; const AOptions: TXLSDeleteOptions = DefaultDeleteOptions);
Public procedure DeleteCells(const ACol1, ARow1, ACol2, ARow2: integer; const AOptions: TXLSDeleteOptions = DefaultDeleteOptions);
Public procedure ClearCell(const ACol, ARow: integer);
Public procedure CelarCells(const ACol1, ARow1, ACol2, ARow2: integer);
Public procedure MoveCell(const ACol, ARow, ADestCol, ADestRow: integer);
Public procedure MoveCells(const ACol1, ARow1, ACol2, ARow2, ADestCol, ADestRow: integer; const ACopyOptions: TCopyCellsOptions = CopyAllCells);
Public function MergeCells(Col1, Row1, Col2, Row2: integer): boolean;
Public procedure DeleteRows(const ARow1,ARow2: integer);
Public procedure ClearRows(const ARow1,ARow2: integer);
Public procedure InsertRows(const ARow,ARowCount: integer);
Public procedure CopyRows(const ARow1,ARow2,ADestRow: integer);
Public procedure MoveRows(const ARow1,ARow2,ADestRow: integer);
Public procedure DeleteColumns(const ACol1,ACol2: integer);
Public procedure ClearColumns(const ACol1,ACol2: integer);
Public procedure InsertColumns(const ACol,AColCount: integer);
Public procedure CopyColumns(const ACol1,ACol2,ADestCol: integer);
Public procedure MoveColumns(const ACol1,ACol2,ADestCol: integer);
Public function IsEmpty: boolean;
Public procedure Sort(const AAscending,ACaseSencitive: boolean); overload;
Public procedure Sort(ACol1, ARow1, ACol2, ARow2: integer; const AAscending,ACaseSencitive: boolean); overload;
Public procedure GroupRows(const ARow1,ARow2: integer; ACollapsed: boolean = False);
Public procedure GroupColumns(const ACol1, ACol2: integer; ACollapsed: boolean = False);
Public procedure RichTextLoadFromFile(const ACol, ARow: integer; const Filename: AxUCString; const AllText: boolean = True);
Public procedure RichTextLoadFromStream(const ACol, ARow: integer; Stream: TStream; const AllText: boolean = True);
Public procedure RichTextSaveToFile(const ACol, ARow: integer; const Filename: AxUCString);
Public procedure RichTextSaveToStream(const ACol, ARow: integer; Stream: TStream);
Public procedure CopyToRichEdit(const ACol,ARow: integer; var ARichEdit: TRichEdit);
Public function FindCell(const ACol,ARow: integer): boolean;
Public procedure BeginFindText;
Public function FindText(const AText: AxUCString; CaseInsensitive: boolean = True): boolean;
Public procedure GetFindData(var ACol,ARow,ATextPos: integer; var AText: AxUCString);
Public function GetFormatString(ACell: TXLSCellItem; AColor: PLongword): AxUCString;
Public procedure InsertFloatRowValues(const ACol,ARow: integer; const AValues: array of double); overload;
Public procedure InsertStringRowValues(const ACol,ARow: integer; const AValues: array of AxUCString); overload;
Public procedure InsertRowValues(const ACol,ARow: integer; const AValues: array of Variant); overload;
Public procedure InsertFloatColValues(const ACol,ARow: integer; const AValues: array of double); overload;
Public procedure InsertStringColValues(const ACol,ARow: integer; const AValues: array of AxUCString); overload;
Public procedure InsertColValues(const ACol,ARow: integer; const AValues: array of Variant); overload;
Public procedure MakeHyperlink(const ACol,ARow: integer; const AAddress, AText: AxUCString); overload;
Public procedure MakeHyperlink(const ACol,ARow: integer; const AAddress, AText,ATooltip: AxUCString); overload;
Public procedure GetShapePixelSize(AShape: TXLSDrwTwoPosShape; out AWidth,AHeight: integer);
Public procedure BeginIterate;
Public function IterateNext: boolean;
Public procedure IteratePos(out ACol,ARow: integer);
Public function FirstCol: integer;
Public function LastCol: integer;
Public function FirstRow: integer;
Public function LastRow: integer;

Properties

Public property LeftCol: integer read GetLeftCol write SetLeftCol;
Public property TopRow: integer read GetTopRow write SetTopRow;
Public property DefaultColWidth: integer read GetDefaultColWidth write SetDefaultColWidth;
Public property DefaultRowHeight: integer read GetDefaultRowHeight write SetDefaultRowHeight;
Public property AsBlank[Col,Row:integer]: boolean read GetAsBlank write SetAsBlank;
Public property AsInteger[Col,Row:integer]: integer read GetAsInteger write SetAsInteger;
Public property AsFloat[Col,Row:integer]: double read GetAsFloat write SetAsFloat;
Public property AsDateTime[Col,Row:integer]: TDateTime read GetAsDateTime write SetAsDateTime;
Public property AsString[Col,Row:integer]: AxUCString read GetAsString write SetAsString;
Public property AsRichText[Col,Row:integer]: AxUCString read GetAsRichText write SetAsRichText;
Public property AsSimpleTags[ACol,ARow:integer]: AxUCString read GetAsSimpleTags write SetAsSimpleTags;
Public property AsFmtString[Col,Row:integer]: AxUCString read GetAsFmtString;
Public property AsHyperlink[Col,Row:integer]: AxUCString read GetAsHyperlink write SetAsHyperlink;
Public property AsHTML[Col,Row:integer]: AxUCString read GetAsHTML;
Public property AsBoolean[Col,Row:integer]: boolean read GetAsBoolean write SetAsBoolean;
Public property AsError[Col,Row:integer]: TXc12CellError read GetAsError write SetAsError;
Public property AsVariant[Col,Row:integer]: Variant read GetAsVariant write SetAsVariant;
Public property AsFormula[Col,Row:integer]: AxUCString read GetAsFormula write SetAsFormula;
Public property AsNumFormulaValue[Col,Row:integer]: double read GetAsNumFormulaValue write SetAsNumFormulaValue;
Public property AsStrFormulaValue[Col,Row:integer]: AxUCString read GetAsStrFormulaValue write SetAsStrFormulaValue;
Public property AsBoolFormulaValue[Col,Row:integer]: boolean read GetAsBoolFormulaValue write SetAsBoolFormulaValue;
Public property IsDateTime[Col,Row:integer]: boolean read GetIsDateTime;
Public property AsBlankRef[constARef:AxUCString]: boolean read GetAsBlankRef write SetAsBlankRef;
Public property AsIntegerRef[constARef:AxUCString]: integer read GetAsIntegerRef write SetAsIntegerRef;
Public property AsFloatRef[constARef:AxUCString]: double read GetAsFloatRef write SetAsFloatRef;
Public property AsDateTimeRef[constARef:AxUCString]: TDateTime read GetAsDateTimeRef write SetAsDateTimeRef;
Public property AsStringRef[constARef:AxUCString]: AxUCString read GetAsStringRef write SetAsStringRef;
Public property AsRichTextRef[constARef:AxUCString]: AxUCString read GetAsRichTextRef write SetAsRichTextRef;
Public property AsSimpleTagsRef[constARef:AxUCString]: AxUCString read GetAsSimpleTagsRef write SetAsSimpleTagsRef;
Public property AsFmtStringRef[constARef:AxUCString]: AxUCString read GetAsFmtStringRef;
Public property AsHTMLRef[constARef:AxUCString]: AxUCString read GetAsHTMLRef;
Public property AsBooleanRef[constARef:AxUCString]: boolean read GetAsBooleanRef write SetAsBooleanRef;
Public property AsErrorRef[constARef:AxUCString]: TXc12CellError read GetAsErrorRef write SetAsErrorRef;
Public property AsFormulaRef[constARef:AxUCString]: AxUCString read GetAsFormulaRef write SetAsFormulaRef;
Public property AsNumFormulaValueRef[constARef:AxUCString]: double read GetAsNumFormulaValueRef write SetAsNumFormulaValueRef;
Public property AsStrFormulaValueRef[constARef:AxUCString]: AxUCString read GetAsStrFormulaValueRef write SetAsStrFormulaValueRef;
Public property AsBoolFormulaValueRef[constARef:AxUCString]: boolean read GetAsBoolFormulaValueRef write SetAsBoolFormulaValueRef;
Public property AsVariantRef[constARef:AxUCString]: Variant read GetAsVariantRef write SetAsVariantRef;
Public property Cell[Col,Row:integer]: TXLSCell read GetCell;
Public property CellType[Col,Row:integer]: TXLSCellType read GetCellType;
Public property FormulaType[Col,Row:integer]: TXLSCellFormulaType read GetFormulaType;
Public property Rows: TXLSRows read GetRows;
Public property Columns: TXLSColumns read GetColumns;
Public property Autofilter: TXLSAutofilter read GetAutofilter;
Public property Hyperlinks: TXLSHyperlinks read GetHyperlinks;
Public property MergedCells: TXLSMergedCells read GetMergedCells;
Public property ConditionalFormats: TXLSConditionalFormats read GetConditionalFormats;
Public property Validations: TXLSDataValidations read GetValidations;
Public property Comments: TXLSComments read FComments;
Public property PrintSettings: TXLSPrintSettings read GetPrintSettings;
Public property SelectedAreas: TXLSSelectedAreas read GetSelectedAreas;
Public property VisibleAreas: TCellAreas read GetVisibleAreas;
Public property Drawing: TXLSDrawing read GetDrawing;
Public property Range: TXLSRange read FRange;
Public property Pane: TXLSPane read GetPane;
Public property Protection: TXLSSheetProtection read FProtection;
Public property Name: AxUCString read GetName write SetName;
Public property TabColor: longword read GetTabColor write SetTabColor;
Public property Options: TXLSSheetOptions read GetOptions write SetOptions;
Public property WorkspaceOptions: TWorkspaceOptions read GetWorkspaceOptions write SetWorkspaceOptions;
Public property Zoom: integer read GetZoom write SetZoom;
Public property ZoomPreview: integer read GetZoomPreview write SetZoomPreview;
Public property RecalcFormulas: boolean read GetRecalcFormulas write SetRecalcFormulas;
Public property Xc12Sheet: TXc12DataWorksheet read FXc12Sheet;
Public property XSSCellInvalidateEvent: TXc12RefEvent read FXSSCellInvalidateEvent write FXSSCellInvalidateEvent;

Description

Methods

Public constructor Create(AClassFactory: TXLSClassFactory; AOwner: TXLSWorkbook; AManager: TXc12Manager; AXc12Sheet: TXc12DataWorksheet);
 
Public destructor Destroy; override;
 
Public function RequestObject(AClass: TClass): TObject; override;
 
Public function MakeFormattedText(const ACell: TXLSCellItem): TXLSFormattedText; overload;
 
Public function MakeFormattedText(const ACol,ARow: integer; var AFormattedText: TXLSFormattedText): boolean; overload;
 
Public procedure Assign(Source: TXLSWorksheet);
 
Public function MMUCells: TXLSCellMMU;
 
Public procedure Clear;
 
Public procedure ClearData;
 
Public procedure ClearWorksheet;
 
Public procedure FillRandom(const AArea: AxUCString;const AValue: integer);

Fills an area with random numbers, from 0 to Value - 1. Usefull for test purpose. ˜param Ref The cell area as a string, like: A1:D9 ˜param Value Max random value - 1.

Public function AutoWidthCol(const ACol: integer): integer;
 
Public procedure AutoWidthCols(const Col1,Col2: integer);
 
Public function AutoHeightRow(const ARow: integer): boolean;
 
Public function AutoHeightRows(const Row1,Row2: integer): boolean;
 
Public procedure AutoSizeCell(const ACol,ARow: integer; const ASizeCol,ASizeRow: boolean);
 
Public procedure UnfreezePanes;

Removes frozen panes created with FreezePanes.

Public procedure FreezePanes(const AColumns,ARows: integer);

Create frozen panes, that is, top rows and/or Left columns are locked. AColumns is the number of locked columns. Set to zero fo no locked columns. ARows is the number of locked rows. Set to zero fo no locked rows. Remove frozen panes with @linkt(UnfreezePanes).

Public procedure UnsplitPanes;

Removes splitted panes created with SplitPanes.

Public procedure SplitPanes(const APointsWidth,APointsHeight: integer);

Creates splitted panes. The width and height is in character points. Remove splitted panes with @linkt(UnsplitPanes).

Public procedure CalcDimensions;

Calculate the dimensions of the worksheet. CalcDimensions will calculate the first and last, first and last column.

Public procedure CalcDimensionsEx;

Calculate the dimensions of the worksheet. CalcDimensions will calculate the first and last, first and last column. Only cells with values are included. Cells with only formatting (blank) are excluded. Consider using CalcDimensions instead as CalcDimensionsEx id *MUCH* slower.

Public function Calculate(const ACol, ARow: integer): Variant;
 
Public function CalculateEx(Col, Row: integer; CalculateOptions: boolean): Variant;
 
Public function CalculateAsString(const ACol, ARow: integer): AxUCString;
 
Public procedure CalculateSheet;
 
Public procedure Calculated(const IsCalculated: boolean);
 
Public procedure CopyCell(const ACol, ARow, ADestCol, ADestRow: integer);
 
Public procedure CopyCells(const ACol1, ARow1, ACol2, ARow2, ADestCol, ADestRow: integer; const ACopyOptions: TCopyCellsOptions = CopyAllCells);
 
Public procedure DeleteCell(const ACol, ARow: integer; const AOptions: TXLSDeleteOptions = DefaultDeleteOptions);
 
Public procedure DeleteCells(const ACol1, ARow1, ACol2, ARow2: integer; const AOptions: TXLSDeleteOptions = DefaultDeleteOptions);
 
Public procedure ClearCell(const ACol, ARow: integer);

Deletes just the cell values

Public procedure CelarCells(const ACol1, ARow1, ACol2, ARow2: integer);
 
Public procedure MoveCell(const ACol, ARow, ADestCol, ADestRow: integer);
 
Public procedure MoveCells(const ACol1, ARow1, ACol2, ARow2, ADestCol, ADestRow: integer; const ACopyOptions: TCopyCellsOptions = CopyAllCells);
 
Public function MergeCells(Col1, Row1, Col2, Row2: integer): boolean;
 
Public procedure DeleteRows(const ARow1,ARow2: integer);

Deletes the rows between ARow1 and ARow2 and shiftes the rows below up. See also ClearRows.

Public procedure ClearRows(const ARow1,ARow2: integer);

Deletes the rows between ARow1 and ARow2. See also DeleteRows.

Public procedure InsertRows(const ARow,ARowCount: integer);
 
Public procedure CopyRows(const ARow1,ARow2,ADestRow: integer);
 
Public procedure MoveRows(const ARow1,ARow2,ADestRow: integer);
 
Public procedure DeleteColumns(const ACol1,ACol2: integer);

Deletes the columns between ACol1 and ACol2 and shiftes the columns to the right left. See also ClearColumns.

Public procedure ClearColumns(const ACol1,ACol2: integer);

Deletes the columns between ACol1 and ACol2. See also ClearColumns.

Public procedure InsertColumns(const ACol,AColCount: integer);
 
Public procedure CopyColumns(const ACol1,ACol2,ADestCol: integer);
 
Public procedure MoveColumns(const ACol1,ACol2,ADestCol: integer);
 
Public function IsEmpty: boolean;
 
Public procedure Sort(const AAscending,ACaseSencitive: boolean); overload;
 
Public procedure Sort(ACol1, ARow1, ACol2, ARow2: integer; const AAscending,ACaseSencitive: boolean); overload;
 
Public procedure GroupRows(const ARow1,ARow2: integer; ACollapsed: boolean = False);
 
Public procedure GroupColumns(const ACol1, ACol2: integer; ACollapsed: boolean = False);
 
Public procedure RichTextLoadFromFile(const ACol, ARow: integer; const Filename: AxUCString; const AllText: boolean = True);
 
Public procedure RichTextLoadFromStream(const ACol, ARow: integer; Stream: TStream; const AllText: boolean = True);
 
Public procedure RichTextSaveToFile(const ACol, ARow: integer; const Filename: AxUCString);
 
Public procedure RichTextSaveToStream(const ACol, ARow: integer; Stream: TStream);
 
Public procedure CopyToRichEdit(const ACol,ARow: integer; var ARichEdit: TRichEdit);
 
Public function FindCell(const ACol,ARow: integer): boolean;
 
Public procedure BeginFindText;
 
Public function FindText(const AText: AxUCString; CaseInsensitive: boolean = True): boolean;
 
Public procedure GetFindData(var ACol,ARow,ATextPos: integer; var AText: AxUCString);
 
Public function GetFormatString(ACell: TXLSCellItem; AColor: PLongword): AxUCString;
 
Public procedure InsertFloatRowValues(const ACol,ARow: integer; const AValues: array of double); overload;
 
Public procedure InsertStringRowValues(const ACol,ARow: integer; const AValues: array of AxUCString); overload;
 
Public procedure InsertRowValues(const ACol,ARow: integer; const AValues: array of Variant); overload;
 
Public procedure InsertFloatColValues(const ACol,ARow: integer; const AValues: array of double); overload;
 
Public procedure InsertStringColValues(const ACol,ARow: integer; const AValues: array of AxUCString); overload;
 
Public procedure InsertColValues(const ACol,ARow: integer; const AValues: array of Variant); overload;
 
Public procedure MakeHyperlink(const ACol,ARow: integer; const AAddress, AText: AxUCString); overload;
 
Public procedure MakeHyperlink(const ACol,ARow: integer; const AAddress, AText,ATooltip: AxUCString); overload;
 
Public procedure GetShapePixelSize(AShape: TXLSDrwTwoPosShape; out AWidth,AHeight: integer);
 
Public procedure BeginIterate;
 
Public function IterateNext: boolean;
 
Public procedure IteratePos(out ACol,ARow: integer);
 
Public function FirstCol: integer;
 
Public function LastCol: integer;
 
Public function FirstRow: integer;
 
Public function LastRow: integer;
 

Properties

Public property LeftCol: integer read GetLeftCol write SetLeftCol;
 
Public property TopRow: integer read GetTopRow write SetTopRow;
 
Public property DefaultColWidth: integer read GetDefaultColWidth write SetDefaultColWidth;
 
Public property DefaultRowHeight: integer read GetDefaultRowHeight write SetDefaultRowHeight;
 
Public property AsBlank[Col,Row:integer]: boolean read GetAsBlank write SetAsBlank;
 
Public property AsInteger[Col,Row:integer]: integer read GetAsInteger write SetAsInteger;
 
Public property AsFloat[Col,Row:integer]: double read GetAsFloat write SetAsFloat;
 
Public property AsDateTime[Col,Row:integer]: TDateTime read GetAsDateTime write SetAsDateTime;
 
Public property AsString[Col,Row:integer]: AxUCString read GetAsString write SetAsString;
 
Public property AsRichText[Col,Row:integer]: AxUCString read GetAsRichText write SetAsRichText;
 
Public property AsSimpleTags[ACol,ARow:integer]: AxUCString read GetAsSimpleTags write SetAsSimpleTags;

AsSimpleTags let you easily create formatted text with html-like tags. There are no end tags. A tag sets an option, and that option is used until a new tags replaces it. In order to write the "<", character, write an empty tag "<>" in the text. Example: 'Two <> one' The following tags can be uses: <b> Turn bold on. </b> Turn bold off. <i> Turn italic on. </i> Turn italic off. <u> Turn underline on. </u> Turn underline off. <f:Font name> Changes the font name. <s:nn> Changes the font size. Setting the size to zero sets the font size to the default size. <c:xxxxxx> Changes the font color. The value xxxxxx is the hexadecimal RGB color value. If xxxxxx is set to 'Auto', the default color will be used.

Public property AsFmtString[Col,Row:integer]: AxUCString read GetAsFmtString;
 
Public property AsHyperlink[Col,Row:integer]: AxUCString read GetAsHyperlink write SetAsHyperlink;
 
Public property AsHTML[Col,Row:integer]: AxUCString read GetAsHTML;
 
Public property AsBoolean[Col,Row:integer]: boolean read GetAsBoolean write SetAsBoolean;
 
Public property AsError[Col,Row:integer]: TXc12CellError read GetAsError write SetAsError;
 
Public property AsVariant[Col,Row:integer]: Variant read GetAsVariant write SetAsVariant;
 
Public property AsFormula[Col,Row:integer]: AxUCString read GetAsFormula write SetAsFormula;
 
Public property AsNumFormulaValue[Col,Row:integer]: double read GetAsNumFormulaValue write SetAsNumFormulaValue;
 
Public property AsStrFormulaValue[Col,Row:integer]: AxUCString read GetAsStrFormulaValue write SetAsStrFormulaValue;
 
Public property AsBoolFormulaValue[Col,Row:integer]: boolean read GetAsBoolFormulaValue write SetAsBoolFormulaValue;
 
Public property IsDateTime[Col,Row:integer]: boolean read GetIsDateTime;
 
Public property AsBlankRef[constARef:AxUCString]: boolean read GetAsBlankRef write SetAsBlankRef;
 
Public property AsIntegerRef[constARef:AxUCString]: integer read GetAsIntegerRef write SetAsIntegerRef;
 
Public property AsFloatRef[constARef:AxUCString]: double read GetAsFloatRef write SetAsFloatRef;
 
Public property AsDateTimeRef[constARef:AxUCString]: TDateTime read GetAsDateTimeRef write SetAsDateTimeRef;
 
Public property AsStringRef[constARef:AxUCString]: AxUCString read GetAsStringRef write SetAsStringRef;
 
Public property AsRichTextRef[constARef:AxUCString]: AxUCString read GetAsRichTextRef write SetAsRichTextRef;
 
Public property AsSimpleTagsRef[constARef:AxUCString]: AxUCString read GetAsSimpleTagsRef write SetAsSimpleTagsRef;
 
Public property AsFmtStringRef[constARef:AxUCString]: AxUCString read GetAsFmtStringRef;
 
Public property AsHTMLRef[constARef:AxUCString]: AxUCString read GetAsHTMLRef;
 
Public property AsBooleanRef[constARef:AxUCString]: boolean read GetAsBooleanRef write SetAsBooleanRef;
 
Public property AsErrorRef[constARef:AxUCString]: TXc12CellError read GetAsErrorRef write SetAsErrorRef;
 
Public property AsFormulaRef[constARef:AxUCString]: AxUCString read GetAsFormulaRef write SetAsFormulaRef;
 
Public property AsNumFormulaValueRef[constARef:AxUCString]: double read GetAsNumFormulaValueRef write SetAsNumFormulaValueRef;
 
Public property AsStrFormulaValueRef[constARef:AxUCString]: AxUCString read GetAsStrFormulaValueRef write SetAsStrFormulaValueRef;
 
Public property AsBoolFormulaValueRef[constARef:AxUCString]: boolean read GetAsBoolFormulaValueRef write SetAsBoolFormulaValueRef;
 
Public property AsVariantRef[constARef:AxUCString]: Variant read GetAsVariantRef write SetAsVariantRef;
 
Public property Cell[Col,Row:integer]: TXLSCell read GetCell;
 
Public property CellType[Col,Row:integer]: TXLSCellType read GetCellType;
 
Public property FormulaType[Col,Row:integer]: TXLSCellFormulaType read GetFormulaType;
 
Public property Rows: TXLSRows read GetRows;
 
Public property Columns: TXLSColumns read GetColumns;
 
Public property Autofilter: TXLSAutofilter read GetAutofilter;
 
Public property Hyperlinks: TXLSHyperlinks read GetHyperlinks;
 
Public property MergedCells: TXLSMergedCells read GetMergedCells;
 
Public property ConditionalFormats: TXLSConditionalFormats read GetConditionalFormats;
 
Public property Validations: TXLSDataValidations read GetValidations;
 
Public property Comments: TXLSComments read FComments;
 
Public property PrintSettings: TXLSPrintSettings read GetPrintSettings;
 
Public property SelectedAreas: TXLSSelectedAreas read GetSelectedAreas;
 
Public property VisibleAreas: TCellAreas read GetVisibleAreas;
 
Public property Drawing: TXLSDrawing read GetDrawing;
 
Public property Range: TXLSRange read FRange;
 
Public property Pane: TXLSPane read GetPane;
 
Public property Protection: TXLSSheetProtection read FProtection;
 
Public property Name: AxUCString read GetName write SetName;
 
Public property TabColor: longword read GetTabColor write SetTabColor;
 
Public property Options: TXLSSheetOptions read GetOptions write SetOptions;
 
Public property WorkspaceOptions: TWorkspaceOptions read GetWorkspaceOptions write SetWorkspaceOptions;
 
Public property Zoom: integer read GetZoom write SetZoom;
 
Public property ZoomPreview: integer read GetZoomPreview write SetZoomPreview;
 
Public property RecalcFormulas: boolean read GetRecalcFormulas write SetRecalcFormulas;
 
Public property Xc12Sheet: TXc12DataWorksheet read FXc12Sheet;
 
Public property XSSCellInvalidateEvent: TXc12RefEvent read FXSSCellInvalidateEvent write FXSSCellInvalidateEvent;
 

Generated by PasDoc 0.12.1 on 2013-03-18 12:36:48